Overview
Brought to you by YData
Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 141250 |
| Missing cells | 893520 |
| Missing cells (%) | 27.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 130.1 MiB |
| Average record size in memory | 965.6 B |
Variable types
| Text | 6 |
|---|---|
| Categorical | 10 |
| Unsupported | 1 |
| Numeric | 4 |
| Boolean | 1 |
| DateTime | 1 |
Card Type has constant value "Credit" | Constant |
Bank Account Type has constant value "Checking" | Constant |
Bank Name has constant value "Bank of Example" | Constant |
AVS Result Code has constant value "True" | Constant |
CVV Result Code has constant value "M" | Constant |
Card Brand is highly overall correlated with Payment Gateway Name | High correlation |
Card Last 4 Digits is highly overall correlated with Payment Gateway Name | High correlation |
Gateway Fees is highly overall correlated with Net Settled Amount and 2 other fields | High correlation |
Gateway Response Message is highly overall correlated with Net Settled Amount and 3 other fields | High correlation |
Net Settled Amount is highly overall correlated with Gateway Fees and 3 other fields | High correlation |
Payment Gateway Name is highly overall correlated with Card Brand and 2 other fields | High correlation |
Transaction Amount is highly overall correlated with Gateway Fees and 3 other fields | High correlation |
Transaction Status is highly overall correlated with Gateway Response Message and 1 other fields | High correlation |
Transaction Type is highly overall correlated with Gateway Response Message and 3 other fields | High correlation |
Transaction Status is highly imbalanced (82.3%) | Imbalance |
Gateway Response Message is highly imbalanced (68.6%) | Imbalance |
Transaction Type is highly imbalanced (68.6%) | Imbalance |
Card Brand has 93954 (66.5%) missing values | Missing |
Card Last 4 Digits has 93954 (66.5%) missing values | Missing |
Card Type has 93954 (66.5%) missing values | Missing |
Token ID has 46844 (33.2%) missing values | Missing |
Bank Account Type has 94406 (66.8%) missing values | Missing |
Bank Name has 94406 (66.8%) missing values | Missing |
PayPal Payer ID has 94140 (66.6%) missing values | Missing |
AVS Result Code has 93954 (66.5%) missing values | Missing |
CVV Result Code has 93954 (66.5%) missing values | Missing |
Acquirer Reference Number (ARN) has 93954 (66.5%) missing values | Missing |
reference_number has unique values | Unique |
Gateway Response Code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2025-07-06 23:53:25.569030 |
|---|---|
| Analysis finished | 2025-07-06 23:53:31.421588 |
| Duration | 5.85 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
| Distinct | 140145 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 139043 ? |
|---|---|
| Unique (%) | 98.4% |
Sample
| 1st row | GW-TRX-9972261 |
|---|---|
| 2nd row | GW-TRX-8455695 |
| 3rd row | GW-TRX-5184318 |
| 4th row | GW-TRX-8104962 |
| 5th row | GW-TRX-2770667 |
| Value | Count | Frequency (%) |
| gw-trx-7907860 | 3 | < 0.1% |
| gw-trx-7322359 | 3 | < 0.1% |
| gw-trx-6671195 | 3 | < 0.1% |
| gw-trx-4056314 | 2 | < 0.1% |
| gw-trx-2412164 | 2 | < 0.1% |
| gw-trx-6392152 | 2 | < 0.1% |
| gw-trx-2151894 | 2 | < 0.1% |
| gw-trx-9560362 | 2 | < 0.1% |
| gw-trx-8952714 | 2 | < 0.1% |
| gw-trx-1465885 | 2 | < 0.1% |
| Other values (140135) | 141227 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 282500 | |
| G | 141250 | 7.1% |
| W | 141250 | 7.1% |
| T | 141250 | 7.1% |
| R | 141250 | 7.1% |
| X | 141250 | 7.1% |
| 2 | 101031 | 5.1% |
| 3 | 100708 | 5.1% |
| 4 | 100656 | 5.1% |
| 6 | 100336 | 5.1% |
| Other values (6) | 586019 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1977500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 282500 | |
| G | 141250 | 7.1% |
| W | 141250 | 7.1% |
| T | 141250 | 7.1% |
| R | 141250 | 7.1% |
| X | 141250 | 7.1% |
| 2 | 101031 | 5.1% |
| 3 | 100708 | 5.1% |
| 4 | 100656 | 5.1% |
| 6 | 100336 | 5.1% |
| Other values (6) | 586019 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1977500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 282500 | |
| G | 141250 | 7.1% |
| W | 141250 | 7.1% |
| T | 141250 | 7.1% |
| R | 141250 | 7.1% |
| X | 141250 | 7.1% |
| 2 | 101031 | 5.1% |
| 3 | 100708 | 5.1% |
| 4 | 100656 | 5.1% |
| 6 | 100336 | 5.1% |
| Other values (6) | 586019 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1977500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 282500 | |
| G | 141250 | 7.1% |
| W | 141250 | 7.1% |
| T | 141250 | 7.1% |
| R | 141250 | 7.1% |
| X | 141250 | 7.1% |
| 2 | 101031 | 5.1% |
| 3 | 100708 | 5.1% |
| 4 | 100656 | 5.1% |
| 6 | 100336 | 5.1% |
| Other values (6) | 586019 |
Payment Gateway Name
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 MiB |
| Cybersource | |
|---|---|
| PayPal | |
| GoCardless |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 9.0007504 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | GoCardless |
| 3rd row | GoCardless |
| 4th row | Cybersource |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| Cybersource | 47296 | |
| PayPal | 47110 | |
| GoCardless | 46844 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| cybersource | 47296 | |
| paypal | 47110 | |
| gocardless | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Transaction Status
Categorical
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.5 MiB |
| settled | |
|---|---|
| disputed | 3750 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.0265487 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | settled |
|---|---|
| 2nd row | settled |
| 3rd row | settled |
| 4th row | settled |
| 5th row | settled |
Common Values
| Value | Count | Frequency (%) |
| settled | 137500 | |
| disputed | 3750 | 2.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| settled | 137500 | |
| disputed | 3750 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 278750 | |
| t | 278750 | |
| d | 145000 | |
| s | 141250 | |
| l | 137500 | |
| i | 3750 | 0.4% |
| p | 3750 | 0.4% |
| u | 3750 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 992500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 278750 | |
| t | 278750 | |
| d | 145000 | |
| s | 141250 | |
| l | 137500 | |
| i | 3750 | 0.4% |
| p | 3750 | 0.4% |
| u | 3750 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 992500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 278750 | |
| t | 278750 | |
| d | 145000 | |
| s | 141250 | |
| l | 137500 | |
| i | 3750 | 0.4% |
| p | 3750 | 0.4% |
| u | 3750 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 992500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 278750 | |
| t | 278750 | |
| d | 145000 | |
| s | 141250 | |
| l | 137500 | |
| i | 3750 | 0.4% |
| p | 3750 | 0.4% |
| u | 3750 | 0.4% |
Gateway Response Code
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 5.5 MiB |
Gateway Response Message
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 MiB |
| Approved | |
|---|---|
| Refund Processed | 12500 |
| Chargeback Initiated | 2500 |
| Chargeback Reversed | 1250 |
Length
| Max length | 20 |
|---|---|
| Median length | 8 |
| Mean length | 9.0176991 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Approved |
|---|---|
| 2nd row | Approved |
| 3rd row | Approved |
| 4th row | Approved |
| 5th row | Approved |
Common Values
| Value | Count | Frequency (%) |
| Approved | 125000 | |
| Refund Processed | 12500 | 8.8% |
| Chargeback Initiated | 2500 | 1.8% |
| Chargeback Reversed | 1250 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| approved | 125000 | |
| refund | 12500 | 7.9% |
| processed | 12500 | 7.9% |
| chargeback | 3750 | 2.4% |
| initiated | 2500 | 1.6% |
| reversed | 1250 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Transaction Amount
Real number (ℝ)
High correlation 
| Distinct | 122801 |
|---|---|
| Distinct (%) | 86.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1979.2208 |
| Minimum | -4999.85 |
|---|---|
| Maximum | 4999.87 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15000 |
| Negative (%) | 10.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -4999.85 |
|---|---|
| 5-th percentile | -2655.288 |
| Q1 | 828.465 |
| median | 2221.17 |
| Q3 | 3607.4425 |
| 95-th percentile | 4724.491 |
| Maximum | 4999.87 |
| Range | 9999.72 |
| Interquartile range (IQR) | 2778.9775 |
Descriptive statistics
| Standard deviation | 2112.685 |
|---|---|
| Coefficient of variation (CV) | 1.0674327 |
| Kurtosis | 1.0466637 |
| Mean | 1979.2208 |
| Median Absolute Deviation (MAD) | 1389.74 |
| Skewness | -1.0062879 |
| Sum | 2.7956493 × 108 |
| Variance | 4463437.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4756.12 | 5 | < 0.1% |
| 953.97 | 5 | < 0.1% |
| 931.3 | 5 | < 0.1% |
| 3543.24 | 5 | < 0.1% |
| 4146.9 | 5 | < 0.1% |
| 1020.37 | 5 | < 0.1% |
| 1902 | 5 | < 0.1% |
| 2595.9 | 5 | < 0.1% |
| 1121 | 4 | < 0.1% |
| 4540.24 | 4 | < 0.1% |
| Other values (122791) | 141202 |
| Value | Count | Frequency (%) |
| -4999.85 | 1 | |
| -4999.06 | 1 | |
| -4998.84 | 2 | |
| -4998.76 | 1 | |
| -4998.23 | 1 | |
| -4996.55 | 2 | |
| -4996.24 | 1 | |
| -4996.23 | 2 | |
| -4996.21 | 2 | |
| -4995.93 | 1 |
| Value | Count | Frequency (%) |
| 4999.87 | 1 | |
| 4999.85 | 2 | |
| 4999.66 | 1 | |
| 4999.61 | 1 | |
| 4999.54 | 1 | |
| 4999.44 | 1 | |
| 4999.28 | 2 | |
| 4999.27 | 1 | |
| 4999.26 | 1 | |
| 4999.24 | 1 |
Transaction Currency
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 MiB |
| USD | |
|---|---|
| EUR | |
| GBP | |
| AUD | |
| CAD |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | GBP |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 84784 | |
| EUR | 21002 | 14.9% |
| GBP | 14100 | 10.0% |
| AUD | 11416 | 8.1% |
| CAD | 9948 | 7.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 84784 | |
| eur | 21002 | 14.9% |
| gbp | 14100 | 10.0% |
| aud | 11416 | 8.1% |
| cad | 9948 | 7.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Transaction Type
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| payment | |
|---|---|
| refund | 12500 |
| chargeback | 2500 |
| chargeback_reversal | 1250 |
Length
| Max length | 19 |
|---|---|
| Median length | 7 |
| Mean length | 7.0707965 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | payment |
|---|---|
| 2nd row | payment |
| 3rd row | payment |
| 4th row | payment |
| 5th row | payment |
Common Values
| Value | Count | Frequency (%) |
| payment | 125000 | |
| refund | 12500 | 8.8% |
| chargeback | 2500 | 1.8% |
| chargeback_reversal | 1250 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 125000 | |
| refund | 12500 | 8.8% |
| chargeback | 2500 | 1.8% |
| chargeback_reversal | 1250 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Card Brand
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 7.5 MiB |
| Mastercard | |
|---|---|
| Visa | |
| Amex |
Length
| Max length | 10 |
|---|---|
| Median length | 4 |
| Mean length | 6.0246955 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Visa |
|---|---|
| 2nd row | Mastercard |
| 3rd row | Amex |
| 4th row | Mastercard |
| 5th row | Visa |
Common Values
| Value | Count | Frequency (%) |
| Mastercard | 15960 | 11.3% |
| Visa | 15697 | 11.1% |
| Amex | 15639 | 11.1% |
| (Missing) | 93954 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mastercard | 15960 | |
| visa | 15697 | |
| amex | 15639 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 47617 | |
| r | 31920 | |
| s | 31657 | |
| e | 31599 | |
| M | 15960 | 5.6% |
| t | 15960 | 5.6% |
| c | 15960 | 5.6% |
| d | 15960 | 5.6% |
| V | 15697 | 5.5% |
| i | 15697 | 5.5% |
| Other values (3) | 46917 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 284944 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 47617 | |
| r | 31920 | |
| s | 31657 | |
| e | 31599 | |
| M | 15960 | 5.6% |
| t | 15960 | 5.6% |
| c | 15960 | 5.6% |
| d | 15960 | 5.6% |
| V | 15697 | 5.5% |
| i | 15697 | 5.5% |
| Other values (3) | 46917 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 284944 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 47617 | |
| r | 31920 | |
| s | 31657 | |
| e | 31599 | |
| M | 15960 | 5.6% |
| t | 15960 | 5.6% |
| c | 15960 | 5.6% |
| d | 15960 | 5.6% |
| V | 15697 | 5.5% |
| i | 15697 | 5.5% |
| Other values (3) | 46917 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 284944 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 47617 | |
| r | 31920 | |
| s | 31657 | |
| e | 31599 | |
| M | 15960 | 5.6% |
| t | 15960 | 5.6% |
| c | 15960 | 5.6% |
| d | 15960 | 5.6% |
| V | 15697 | 5.5% |
| i | 15697 | 5.5% |
| Other values (3) | 46917 |
Card Last 4 Digits
Real number (ℝ)
High correlation  Missing 
| Distinct | 8963 |
|---|---|
| Distinct (%) | 19.0% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5511.9391 |
| Minimum | 1000 |
|---|---|
| Maximum | 9999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 1459.75 |
| Q1 | 3267 |
| median | 5540.5 |
| Q3 | 7743.25 |
| 95-th percentile | 9541 |
| Maximum | 9999 |
| Range | 8999 |
| Interquartile range (IQR) | 4476.25 |
Descriptive statistics
| Standard deviation | 2588.5975 |
|---|---|
| Coefficient of variation (CV) | 0.46963463 |
| Kurtosis | -1.1929835 |
| Mean | 5511.9391 |
| Median Absolute Deviation (MAD) | 2238.5 |
| Skewness | -0.0087537714 |
| Sum | 2.6069267 × 108 |
| Variance | 6700836.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5062 | 16 | < 0.1% |
| 2609 | 15 | < 0.1% |
| 9615 | 15 | < 0.1% |
| 9126 | 15 | < 0.1% |
| 9930 | 15 | < 0.1% |
| 7952 | 14 | < 0.1% |
| 6197 | 14 | < 0.1% |
| 4571 | 14 | < 0.1% |
| 3207 | 14 | < 0.1% |
| 3872 | 14 | < 0.1% |
| Other values (8953) | 47150 | |
| (Missing) | 93954 |
| Value | Count | Frequency (%) |
| 1000 | 3 | |
| 1001 | 4 | |
| 1002 | 3 | |
| 1003 | 4 | |
| 1004 | 3 | |
| 1005 | 5 | |
| 1006 | 7 | |
| 1007 | 5 | |
| 1008 | 3 | |
| 1009 | 6 |
| Value | Count | Frequency (%) |
| 9999 | 7 | |
| 9998 | 8 | |
| 9997 | 7 | |
| 9996 | 5 | |
| 9995 | 5 | |
| 9994 | 6 | |
| 9993 | 5 | |
| 9992 | 7 | |
| 9991 | 8 | |
| 9990 | 7 |
Card Type
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 7.5 MiB |
| Credit |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Credit |
|---|---|
| 2nd row | Credit |
| 3rd row | Credit |
| 4th row | Credit |
| 5th row | Credit |
Common Values
| Value | Count | Frequency (%) |
| Credit | 47296 | |
| (Missing) | 93954 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| credit | 47296 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 47296 | |
| r | 47296 | |
| e | 47296 | |
| d | 47296 | |
| i | 47296 | |
| t | 47296 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 283776 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 47296 | |
| r | 47296 | |
| e | 47296 | |
| d | 47296 | |
| i | 47296 | |
| t | 47296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 283776 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 47296 | |
| r | 47296 | |
| e | 47296 | |
| d | 47296 | |
| i | 47296 | |
| t | 47296 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 283776 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 47296 | |
| r | 47296 | |
| e | 47296 | |
| d | 47296 | |
| i | 47296 | |
| t | 47296 |
Token ID
Text
Missing 
| Distinct | 89597 |
|---|---|
| Distinct (%) | 94.9% |
| Missing | 46844 |
| Missing (%) | 33.2% |
| Memory size | 6.7 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 84954 ? |
|---|---|
| Unique (%) | 90.0% |
Sample
| 1st row | TOK_850912 |
|---|---|
| 2nd row | TOK_268155 |
| 3rd row | TOK_866077 |
| 4th row | TOK_244127 |
| 5th row | TOK_513827 |
| Value | Count | Frequency (%) |
| tok_962548 | 4 | < 0.1% |
| tok_646979 | 4 | < 0.1% |
| tok_257937 | 4 | < 0.1% |
| tok_974943 | 4 | < 0.1% |
| tok_820511 | 4 | < 0.1% |
| tok_973529 | 4 | < 0.1% |
| tok_769620 | 4 | < 0.1% |
| tok_426828 | 3 | < 0.1% |
| tok_848212 | 3 | < 0.1% |
| tok_265257 | 3 | < 0.1% |
| Other values (89587) | 94369 |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 94406 | |
| O | 94406 | |
| K | 94406 | |
| _ | 94406 | |
| 4 | 58303 | 6.2% |
| 2 | 57878 | 6.1% |
| 7 | 57825 | 6.1% |
| 1 | 57804 | 6.1% |
| 9 | 57751 | 6.1% |
| 8 | 57626 | 6.1% |
| Other values (4) | 219249 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 944060 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 94406 | |
| O | 94406 | |
| K | 94406 | |
| _ | 94406 | |
| 4 | 58303 | 6.2% |
| 2 | 57878 | 6.1% |
| 7 | 57825 | 6.1% |
| 1 | 57804 | 6.1% |
| 9 | 57751 | 6.1% |
| 8 | 57626 | 6.1% |
| Other values (4) | 219249 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 944060 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 94406 | |
| O | 94406 | |
| K | 94406 | |
| _ | 94406 | |
| 4 | 58303 | 6.2% |
| 2 | 57878 | 6.1% |
| 7 | 57825 | 6.1% |
| 1 | 57804 | 6.1% |
| 9 | 57751 | 6.1% |
| 8 | 57626 | 6.1% |
| Other values (4) | 219249 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 944060 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 94406 | |
| O | 94406 | |
| K | 94406 | |
| _ | 94406 | |
| 4 | 58303 | 6.2% |
| 2 | 57878 | 6.1% |
| 7 | 57825 | 6.1% |
| 1 | 57804 | 6.1% |
| 9 | 57751 | 6.1% |
| 8 | 57626 | 6.1% |
| Other values (4) | 219249 |
Bank Account Type
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 94406 |
| Missing (%) | 66.8% |
| Memory size | 7.6 MiB |
| Checking |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Checking |
|---|---|
| 2nd row | Checking |
| 3rd row | Checking |
| 4th row | Checking |
| 5th row | Checking |
Common Values
| Value | Count | Frequency (%) |
| Checking | 46844 | |
| (Missing) | 94406 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| checking | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 46844 | |
| h | 46844 | |
| e | 46844 | |
| c | 46844 | |
| k | 46844 | |
| i | 46844 | |
| n | 46844 | |
| g | 46844 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 374752 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 46844 | |
| h | 46844 | |
| e | 46844 | |
| c | 46844 | |
| k | 46844 | |
| i | 46844 | |
| n | 46844 | |
| g | 46844 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 374752 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 46844 | |
| h | 46844 | |
| e | 46844 | |
| c | 46844 | |
| k | 46844 | |
| i | 46844 | |
| n | 46844 | |
| g | 46844 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 374752 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 46844 | |
| h | 46844 | |
| e | 46844 | |
| c | 46844 | |
| k | 46844 | |
| i | 46844 | |
| n | 46844 | |
| g | 46844 |
Bank Name
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 94406 |
| Missing (%) | 66.8% |
| Memory size | 7.9 MiB |
| Bank of Example |
|---|
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bank of Example |
|---|---|
| 2nd row | Bank of Example |
| 3rd row | Bank of Example |
| 4th row | Bank of Example |
| 5th row | Bank of Example |
Common Values
| Value | Count | Frequency (%) |
| Bank of Example | 46844 | |
| (Missing) | 94406 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| bank | 46844 | |
| of | 46844 | |
| example | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 93688 | |
| 93688 | ||
| B | 46844 | 6.7% |
| n | 46844 | 6.7% |
| k | 46844 | 6.7% |
| o | 46844 | 6.7% |
| f | 46844 | 6.7% |
| E | 46844 | 6.7% |
| x | 46844 | 6.7% |
| m | 46844 | 6.7% |
| Other values (3) | 140532 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 702660 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 93688 | |
| 93688 | ||
| B | 46844 | 6.7% |
| n | 46844 | 6.7% |
| k | 46844 | 6.7% |
| o | 46844 | 6.7% |
| f | 46844 | 6.7% |
| E | 46844 | 6.7% |
| x | 46844 | 6.7% |
| m | 46844 | 6.7% |
| Other values (3) | 140532 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 702660 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 93688 | |
| 93688 | ||
| B | 46844 | 6.7% |
| n | 46844 | 6.7% |
| k | 46844 | 6.7% |
| o | 46844 | 6.7% |
| f | 46844 | 6.7% |
| E | 46844 | 6.7% |
| x | 46844 | 6.7% |
| m | 46844 | 6.7% |
| Other values (3) | 140532 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 702660 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 93688 | |
| 93688 | ||
| B | 46844 | 6.7% |
| n | 46844 | 6.7% |
| k | 46844 | 6.7% |
| o | 46844 | 6.7% |
| f | 46844 | 6.7% |
| E | 46844 | 6.7% |
| x | 46844 | 6.7% |
| m | 46844 | 6.7% |
| Other values (3) | 140532 |
PayPal Payer ID
Text
Missing 
| Distinct | 36639 |
|---|---|
| Distinct (%) | 77.8% |
| Missing | 94140 |
| Missing (%) | 66.6% |
| Memory size | 5.6 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 27837 ? |
|---|---|
| Unique (%) | 59.1% |
Sample
| 1st row | PAYPAL_68156 |
|---|---|
| 2nd row | PAYPAL_39472 |
| 3rd row | PAYPAL_70561 |
| 4th row | PAYPAL_58053 |
| 5th row | PAYPAL_14028 |
| Value | Count | Frequency (%) |
| paypal_74333 | 6 | < 0.1% |
| paypal_64956 | 6 | < 0.1% |
| paypal_34329 | 6 | < 0.1% |
| paypal_85624 | 6 | < 0.1% |
| paypal_91684 | 6 | < 0.1% |
| paypal_64341 | 5 | < 0.1% |
| paypal_67055 | 5 | < 0.1% |
| paypal_57454 | 5 | < 0.1% |
| paypal_60070 | 5 | < 0.1% |
| paypal_14087 | 5 | < 0.1% |
| Other values (36629) | 47055 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 94220 | |
| A | 94220 | |
| Y | 47110 | |
| L | 47110 | |
| _ | 47110 | |
| 6 | 24334 | 4.3% |
| 1 | 24257 | 4.3% |
| 7 | 24129 | 4.3% |
| 9 | 24071 | 4.3% |
| 2 | 24058 | 4.3% |
| Other values (5) | 114701 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 565320 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 94220 | |
| A | 94220 | |
| Y | 47110 | |
| L | 47110 | |
| _ | 47110 | |
| 6 | 24334 | 4.3% |
| 1 | 24257 | 4.3% |
| 7 | 24129 | 4.3% |
| 9 | 24071 | 4.3% |
| 2 | 24058 | 4.3% |
| Other values (5) | 114701 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 565320 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 94220 | |
| A | 94220 | |
| Y | 47110 | |
| L | 47110 | |
| _ | 47110 | |
| 6 | 24334 | 4.3% |
| 1 | 24257 | 4.3% |
| 7 | 24129 | 4.3% |
| 9 | 24071 | 4.3% |
| 2 | 24058 | 4.3% |
| Other values (5) | 114701 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 565320 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 94220 | |
| A | 94220 | |
| Y | 47110 | |
| L | 47110 | |
| _ | 47110 | |
| 6 | 24334 | 4.3% |
| 1 | 24257 | 4.3% |
| 7 | 24129 | 4.3% |
| 9 | 24071 | 4.3% |
| 2 | 24058 | 4.3% |
| Other values (5) | 114701 |
AVS Result Code
Boolean
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 276.0 KiB |
| True | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 47296 | |
| (Missing) | 93954 |
CVV Result Code
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 7.3 MiB |
| M |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| M | 47296 | |
| (Missing) | 93954 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 47296 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 47296 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 47296 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 47296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 47296 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 47296 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 47296 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 47296 |
| Distinct | 130917 |
|---|---|
| Distinct (%) | 92.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 121088 ? |
|---|---|
| Unique (%) | 85.7% |
Sample
| 1st row | AUTH698092 |
|---|---|
| 2nd row | AUTH259525 |
| 3rd row | AUTH662545 |
| 4th row | AUTH779374 |
| 5th row | AUTH375526 |
| Value | Count | Frequency (%) |
| auth479890 | 4 | < 0.1% |
| auth627885 | 4 | < 0.1% |
| auth181464 | 4 | < 0.1% |
| auth685219 | 4 | < 0.1% |
| auth776662 | 4 | < 0.1% |
| auth571739 | 4 | < 0.1% |
| auth344919 | 4 | < 0.1% |
| auth963043 | 4 | < 0.1% |
| auth813614 | 4 | < 0.1% |
| auth682755 | 4 | < 0.1% |
| Other values (130907) | 141210 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 141250 | |
| U | 141250 | |
| T | 141250 | |
| H | 141250 | |
| 9 | 86690 | 6.1% |
| 8 | 86510 | 6.1% |
| 3 | 86496 | 6.1% |
| 2 | 86448 | 6.1% |
| 6 | 86364 | 6.1% |
| 1 | 86225 | 6.1% |
| Other values (4) | 328767 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1412500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 141250 | |
| U | 141250 | |
| T | 141250 | |
| H | 141250 | |
| 9 | 86690 | 6.1% |
| 8 | 86510 | 6.1% |
| 3 | 86496 | 6.1% |
| 2 | 86448 | 6.1% |
| 6 | 86364 | 6.1% |
| 1 | 86225 | 6.1% |
| Other values (4) | 328767 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1412500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 141250 | |
| U | 141250 | |
| T | 141250 | |
| H | 141250 | |
| 9 | 86690 | 6.1% |
| 8 | 86510 | 6.1% |
| 3 | 86496 | 6.1% |
| 2 | 86448 | 6.1% |
| 6 | 86364 | 6.1% |
| 1 | 86225 | 6.1% |
| Other values (4) | 328767 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1412500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 141250 | |
| U | 141250 | |
| T | 141250 | |
| H | 141250 | |
| 9 | 86690 | 6.1% |
| 8 | 86510 | 6.1% |
| 3 | 86496 | 6.1% |
| 2 | 86448 | 6.1% |
| 6 | 86364 | 6.1% |
| 1 | 86225 | 6.1% |
| Other values (4) | 328767 |
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-01 00:00:00 |
|---|---|
| Maximum | 2025-03-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Gateway Fees
Real number (ℝ)
High correlation 
| Distinct | 4995 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.796576 |
| Minimum | 0.06 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0.06 |
|---|---|
| 5-th percentile | 1.29 |
| Q1 | 6.03 |
| median | 11.95 |
| Q3 | 26.94 |
| 95-th percentile | 42.63 |
| Maximum | 50 |
| Range | 49.94 |
| Interquartile range (IQR) | 20.91 |
Descriptive statistics
| Standard deviation | 13.173946 |
|---|---|
| Coefficient of variation (CV) | 0.78432333 |
| Kurtosis | -0.60008441 |
| Mean | 16.796576 |
| Median Absolute Deviation (MAD) | 8.4 |
| Skewness | 0.71942814 |
| Sum | 2372516.3 |
| Variance | 173.55286 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10.64 | 92 | 0.1% |
| 4.84 | 89 | 0.1% |
| 3.19 | 85 | 0.1% |
| 3.94 | 85 | 0.1% |
| 6.85 | 84 | 0.1% |
| 7.99 | 84 | 0.1% |
| 7.95 | 83 | 0.1% |
| 5.61 | 83 | 0.1% |
| 1.07 | 83 | 0.1% |
| 5.52 | 83 | 0.1% |
| Other values (4985) | 140399 |
| Value | Count | Frequency (%) |
| 0.06 | 12 | < 0.1% |
| 0.07 | 36 | |
| 0.08 | 48 | |
| 0.09 | 30 | |
| 0.1 | 38 | |
| 0.11 | 42 | |
| 0.12 | 46 | |
| 0.13 | 35 | |
| 0.14 | 38 | |
| 0.15 | 42 |
| Value | Count | Frequency (%) |
| 50 | 2 | < 0.1% |
| 49.99 | 6 | < 0.1% |
| 49.98 | 6 | < 0.1% |
| 49.97 | 4 | < 0.1% |
| 49.96 | 14 | |
| 49.95 | 12 | |
| 49.94 | 10 | |
| 49.93 | 15 | |
| 49.92 | 6 | < 0.1% |
| 49.91 | 6 | < 0.1% |
Net Settled Amount
Real number (ℝ)
High correlation 
| Distinct | 124790 |
|---|---|
| Distinct (%) | 88.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1962.4242 |
| Minimum | -5046.2 |
|---|---|
| Maximum | 4987.37 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15000 |
| Negative (%) | 10.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -5046.2 |
|---|---|
| 5-th percentile | -2672.5785 |
| Q1 | 822.68 |
| median | 2206.12 |
| Q3 | 3583.4875 |
| 95-th percentile | 4692.4065 |
| Maximum | 4987.37 |
| Range | 10033.57 |
| Interquartile range (IQR) | 2760.8075 |
Descriptive statistics
| Standard deviation | 2107.6026 |
|---|---|
| Coefficient of variation (CV) | 1.0739791 |
| Kurtosis | 1.0941128 |
| Mean | 1962.4242 |
| Median Absolute Deviation (MAD) | 1380.015 |
| Skewness | -1.0220654 |
| Sum | 2.7719242 × 108 |
| Variance | 4441988.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3385.57 | 5 | < 0.1% |
| 3300.21 | 5 | < 0.1% |
| 2897.74 | 5 | < 0.1% |
| 4796.47 | 5 | < 0.1% |
| 2508.85 | 4 | < 0.1% |
| 740.26 | 4 | < 0.1% |
| 1054.78 | 4 | < 0.1% |
| 1727.27 | 4 | < 0.1% |
| 2273.48 | 4 | < 0.1% |
| 1768.97 | 4 | < 0.1% |
| Other values (124780) | 141206 |
| Value | Count | Frequency (%) |
| -5046.2 | 1 | |
| -5045.89 | 1 | |
| -5045.17 | 1 | |
| -5044.44 | 1 | |
| -5044.03 | 1 | |
| -5042.96 | 1 | |
| -5042.84 | 1 | |
| -5042.64 | 1 | |
| -5039.5 | 1 | |
| -5039.08 | 1 |
| Value | Count | Frequency (%) |
| 4987.37 | 1 | |
| 4987.35 | 1 | |
| 4987.11 | 1 | |
| 4987.04 | 1 | |
| 4986.94 | 1 | |
| 4986.78 | 2 | |
| 4986.68 | 1 | |
| 4986.35 | 1 | |
| 4986.34 | 1 | |
| 4986.23 | 1 |
Acquirer Reference Number (ARN)
Text
Missing 
| Distinct | 47296 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 5.6 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 47296 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | ARN618188908 |
|---|---|
| 2nd row | ARN591055160 |
| 3rd row | ARN184492302 |
| 4th row | ARN314680266 |
| 5th row | ARN615595718 |
| Value | Count | Frequency (%) |
| arn276300877 | 1 | < 0.1% |
| arn213177541 | 1 | < 0.1% |
| arn669849388 | 1 | < 0.1% |
| arn629677896 | 1 | < 0.1% |
| arn591055160 | 1 | < 0.1% |
| arn184492302 | 1 | < 0.1% |
| arn314680266 | 1 | < 0.1% |
| arn615595718 | 1 | < 0.1% |
| arn594832966 | 1 | < 0.1% |
| arn508354528 | 1 | < 0.1% |
| Other values (47286) | 47286 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 47296 | 8.3% |
| R | 47296 | 8.3% |
| N | 47296 | 8.3% |
| 2 | 43333 | 7.6% |
| 3 | 43163 | 7.6% |
| 6 | 43124 | 7.6% |
| 7 | 43103 | 7.6% |
| 9 | 43094 | 7.6% |
| 5 | 43048 | 7.6% |
| 8 | 43038 | 7.6% |
| Other values (3) | 123761 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 567552 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 47296 | 8.3% |
| R | 47296 | 8.3% |
| N | 47296 | 8.3% |
| 2 | 43333 | 7.6% |
| 3 | 43163 | 7.6% |
| 6 | 43124 | 7.6% |
| 7 | 43103 | 7.6% |
| 9 | 43094 | 7.6% |
| 5 | 43048 | 7.6% |
| 8 | 43038 | 7.6% |
| Other values (3) | 123761 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 567552 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 47296 | 8.3% |
| R | 47296 | 8.3% |
| N | 47296 | 8.3% |
| 2 | 43333 | 7.6% |
| 3 | 43163 | 7.6% |
| 6 | 43124 | 7.6% |
| 7 | 43103 | 7.6% |
| 9 | 43094 | 7.6% |
| 5 | 43048 | 7.6% |
| 8 | 43038 | 7.6% |
| Other values (3) | 123761 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 567552 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 47296 | 8.3% |
| R | 47296 | 8.3% |
| N | 47296 | 8.3% |
| 2 | 43333 | 7.6% |
| 3 | 43163 | 7.6% |
| 6 | 43124 | 7.6% |
| 7 | 43103 | 7.6% |
| 9 | 43094 | 7.6% |
| 5 | 43048 | 7.6% |
| 8 | 43038 | 7.6% |
| Other values (3) | 123761 |
reference_number
Text
Unique 
| Distinct | 141250 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.1 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 141250 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | PAY-0000000 |
|---|---|
| 2nd row | PAY-0000001 |
| 3rd row | PAY-0000002 |
| 4th row | PAY-0000003 |
| 5th row | PAY-0000004 |
| Value | Count | Frequency (%) |
| pay-0000000 | 1 | < 0.1% |
| pay-0000011 | 1 | < 0.1% |
| pay-0000017 | 1 | < 0.1% |
| pay-0000016 | 1 | < 0.1% |
| pay-0000015 | 1 | < 0.1% |
| pay-0000014 | 1 | < 0.1% |
| pay-0000013 | 1 | < 0.1% |
| pay-0000012 | 1 | < 0.1% |
| pay-0000010 | 1 | < 0.1% |
| pay-0000070 | 1 | < 0.1% |
| Other values (141240) | 141240 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| - | 141250 | |
| P | 125000 | 8.0% |
| Y | 125000 | 8.0% |
| A | 125000 | 8.0% |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (11) | 317818 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| - | 141250 | |
| P | 125000 | 8.0% |
| Y | 125000 | 8.0% |
| A | 125000 | 8.0% |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (11) | 317818 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| - | 141250 | |
| P | 125000 | 8.0% |
| Y | 125000 | 8.0% |
| A | 125000 | 8.0% |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (11) | 317818 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| - | 141250 | |
| P | 125000 | 8.0% |
| Y | 125000 | 8.0% |
| A | 125000 | 8.0% |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (11) | 317818 |
Interactions
Correlations
| Card Brand | Card Last 4 Digits | Gateway Fees | Gateway Response Message | Net Settled Amount | Payment Gateway Name | Transaction Amount | Transaction Currency | Transaction Status | Transaction Type | |
|---|---|---|---|---|---|---|---|---|---|---|
| Card Brand | 1.000 | 0.000 | 0.013 | 0.000 | 0.012 | 1.000 | 0.012 | 0.006 | 0.000 | 0.000 |
| Card Last 4 Digits | 0.000 | 1.000 | 0.004 | 0.000 | 0.005 | 1.000 | 0.005 | 0.000 | 0.000 | 0.000 |
| Gateway Fees | 0.013 | 0.004 | 1.000 | 0.000 | 0.594 | 0.508 | 0.597 | 0.004 | 0.001 | 0.000 |
| Gateway Response Message | 0.000 | 0.000 | 0.000 | 1.000 | 0.577 | 0.000 | 0.577 | 0.000 | 1.000 | 1.000 |
| Net Settled Amount | 0.012 | 0.005 | 0.594 | 0.577 | 1.000 | 0.000 | 1.000 | 0.004 | 0.300 | 0.577 |
| Payment Gateway Name | 1.000 | 1.000 | 0.508 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.005 | 0.000 |
| Transaction Amount | 0.012 | 0.005 | 0.597 | 0.577 | 1.000 | 0.000 | 1.000 | 0.004 | 0.301 | 0.577 |
| Transaction Currency | 0.006 | 0.000 | 0.004 | 0.000 | 0.004 | 0.000 | 0.004 | 1.000 | 0.000 | 0.000 |
| Transaction Status | 0.000 | 0.000 | 0.001 | 1.000 | 0.300 | 0.005 | 0.301 | 0.000 | 1.000 | 1.000 |
| Transaction Type | 0.000 | 0.000 | 0.000 | 1.000 | 0.577 | 0.000 | 0.577 | 0.000 | 1.000 | 1.000 |
Missing values
Sample
| Gateway Transaction ID | Payment Gateway Name | Transaction Status | Gateway Response Code | Gateway Response Message | Transaction Amount | Transaction Currency | Transaction Type | Card Brand | Card Last 4 Digits | Card Type | Token ID | Bank Account Type | Bank Name | PayPal Payer ID | AVS Result Code | CVV Result Code | Authorization Code | Gateway Timestamp | Gateway Fees | Net Settled Amount | Acquirer Reference Number (ARN) | reference_number | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | GW-TRX-9972261 | PayPal | settled | 0 | Approved | 2592.98 | USD | payment | NaN | NaN | NaN | TOK_850912 | NaN | NaN | PAYPAL_68156 | NaN | NaN | AUTH698092 | 2025-01-30 | 19.45 | 2573.53 | NaN | PAY-0000000 |
| 1 | GW-TRX-8455695 | GoCardless | settled | 0 | Approved | 4277.28 | USD | payment | NaN | NaN | NaN | NaN | Checking | Bank of Example | NaN | NaN | NaN | AUTH259525 | 2025-01-10 | 10.69 | 4266.59 | NaN | PAY-0000001 |
| 2 | GW-TRX-5184318 | GoCardless | settled | 0 | Approved | 2515.78 | USD | payment | NaN | NaN | NaN | NaN | Checking | Bank of Example | NaN | NaN | NaN | AUTH662545 | 2025-02-21 | 6.29 | 2509.49 | NaN | PAY-0000002 |
| 3 | GW-TRX-8104962 | Cybersource | settled | 0 | Approved | 2874.81 | GBP | payment | Visa | 9887.0 | Credit | TOK_268155 | NaN | NaN | NaN | Y | M | AUTH779374 | 2025-01-04 | 28.75 | 2846.06 | ARN618188908 | PAY-0000003 |
| 4 | GW-TRX-2770667 | PayPal | settled | 0 | Approved | 350.01 | USD | payment | NaN | NaN | NaN | TOK_866077 | NaN | NaN | PAYPAL_39472 | NaN | NaN | AUTH375526 | 2025-03-16 | 2.63 | 347.38 | NaN | PAY-0000004 |
| 5 | GW-TRX-8558984 | Cybersource | settled | 0 | Approved | 4412.91 | USD | payment | Mastercard | 9534.0 | Credit | TOK_244127 | NaN | NaN | NaN | Y | M | AUTH730663 | 2025-02-10 | 44.13 | 4368.78 | ARN591055160 | PAY-0000005 |
| 6 | GW-TRX-5053867 | GoCardless | settled | 0 | Approved | 399.15 | AUD | payment | NaN | NaN | NaN | NaN | Checking | Bank of Example | NaN | NaN | NaN | AUTH539557 | 2025-02-07 | 1.00 | 398.15 | NaN | PAY-0000006 |
| 7 | GW-TRX-1689560 | GoCardless | settled | 0 | Approved | 1639.12 | GBP | payment | NaN | NaN | NaN | NaN | Checking | Bank of Example | NaN | NaN | NaN | AUTH580595 | 2025-02-20 | 4.10 | 1635.02 | NaN | PAY-0000007 |
| 8 | GW-TRX-5187601 | Cybersource | settled | 0 | Approved | 802.45 | USD | payment | Amex | 2535.0 | Credit | TOK_513827 | NaN | NaN | NaN | Y | M | AUTH122940 | 2025-02-25 | 8.02 | 794.43 | ARN184492302 | PAY-0000008 |
| 9 | GW-TRX-8963563 | Cybersource | settled | 0 | Approved | 4780.71 | USD | payment | Mastercard | 6108.0 | Credit | TOK_505369 | NaN | NaN | NaN | Y | M | AUTH575960 | 2025-02-23 | 47.81 | 4732.90 | ARN314680266 | PAY-0000009 |
| Gateway Transaction ID | Payment Gateway Name | Transaction Status | Gateway Response Code | Gateway Response Message | Transaction Amount | Transaction Currency | Transaction Type | Card Brand | Card Last 4 Digits | Card Type | Token ID | Bank Account Type | Bank Name | PayPal Payer ID | AVS Result Code | CVV Result Code | Authorization Code | Gateway Timestamp | Gateway Fees | Net Settled Amount | Acquirer Reference Number (ARN) | reference_number | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141240 | GW-TRX-8740287 | GoCardless | disputed | C02 | Chargeback Reversed | 689.24 | USD | chargeback_reversal | NaN | NaN | NaN | NaN | Checking | Bank of Example | NaN | NaN | NaN | AUTH406341 | 2025-03-26 | 1.72 | 687.52 | NaN | REV-0107910 |
| 141241 | GW-TRX-2880464 | Cybersource | disputed | C02 | Chargeback Reversed | 2318.44 | USD | chargeback_reversal | Mastercard | 5928.0 | Credit | TOK_629291 | NaN | NaN | NaN | Y | M | AUTH545329 | 2025-03-06 | 23.18 | 2295.26 | ARN263111260 | REV-0024103 |
| 141242 | GW-TRX-8746072 | Cybersource | disputed | C02 | Chargeback Reversed | 4353.13 | CAD | chargeback_reversal | Amex | 8590.0 | Credit | TOK_952318 | NaN | NaN | NaN | Y | M | AUTH106225 | 2025-03-11 | 43.53 | 4309.60 | ARN135414927 | REV-0039969 |
| 141243 | GW-TRX-9992588 | PayPal | disputed | C02 | Chargeback Reversed | 28.61 | GBP | chargeback_reversal | NaN | NaN | NaN | TOK_718010 | NaN | NaN | PAYPAL_61698 | NaN | NaN | AUTH401048 | 2025-01-31 | 0.21 | 28.40 | NaN | REV-0101060 |
| 141244 | GW-TRX-4931445 | GoCardless | disputed | C02 | Chargeback Reversed | 2263.30 | USD | chargeback_reversal | NaN | NaN | NaN | NaN | Checking | Bank of Example | NaN | NaN | NaN | AUTH580522 | 2025-01-24 | 5.66 | 2257.64 | NaN | REV-0020178 |
| 141245 | GW-TRX-3674175 | GoCardless | disputed | C02 | Chargeback Reversed | 2573.44 | USD | chargeback_reversal | NaN | NaN | NaN | NaN | Checking | Bank of Example | NaN | NaN | NaN | AUTH488942 | 2025-03-12 | 6.43 | 2567.01 | NaN | REV-0025245 |
| 141246 | GW-TRX-7067200 | Cybersource | disputed | C02 | Chargeback Reversed | 794.03 | EUR | chargeback_reversal | Amex | 8120.0 | Credit | TOK_778198 | NaN | NaN | NaN | Y | M | AUTH370822 | 2025-01-01 | 7.94 | 786.09 | ARN131111169 | REV-0093761 |
| 141247 | GW-TRX-1013476 | PayPal | disputed | C02 | Chargeback Reversed | 3629.53 | USD | chargeback_reversal | NaN | NaN | NaN | TOK_797724 | NaN | NaN | PAYPAL_12773 | NaN | NaN | AUTH463738 | 2025-02-13 | 27.22 | 3602.31 | NaN | REV-0103102 |
| 141248 | GW-TRX-4629535 | Cybersource | disputed | C02 | Chargeback Reversed | 2700.28 | USD | chargeback_reversal | Mastercard | 8696.0 | Credit | TOK_890568 | NaN | NaN | NaN | Y | M | AUTH300557 | 2025-02-10 | 27.00 | 2673.28 | ARN894657558 | REV-0039089 |
| 141249 | GW-TRX-7889594 | GoCardless | disputed | C02 | Chargeback Reversed | 2500.12 | CAD | chargeback_reversal | NaN | NaN | NaN | NaN | Checking | Bank of Example | NaN | NaN | NaN | AUTH961626 | 2025-01-05 | 6.25 | 2493.87 | NaN | REV-0022422 |